<?php
  if (session_status() == PHP_SESSION_NONE) {
    session_start();
}
   if(!isset($_SESSION['adm'])) header("location: index.php");
	error_reporting( ~E_NOTICE ); // avoid notice
	
	require_once 'dbconfig.php';
	$pcode = $_GET['productcode'] ;
	$getproduct = $DB_con->prepare("select * from grain where productcode = $pcode" ) ;
	$getproduct->execute() ;
	while($row = $getproduct->fetch(pdo::FETCH_ASSOC) )
	{
	if($row['measure'] == 'Cup') $percupx = $row['amount'] ;
	if($row['measure'] == 'Bag') $perbagx = $row['amount'] ;
    if($row['measure'] == 'Half Bag') $halfbagx = $row['amount'] ;
	if($row['measure'] == 'Penta Bucket') $perpentax = $row['amount'] ;
	if($row['measure'] == 'Half Penta') $halfpentax = $row['amount'] ;
	if($row['measure'] == 'Litre') $perliterx = $row['amount'] ;
	
	}
	//get product name
	$getproductn = $DB_con->prepare("select * from products where product_code = $pcode" ) ;
	$getproductn->execute() ;
	$rown = $getproductn->fetch(pdo::FETCH_ASSOC) ;
	$product = $rown['product_name'] ;
	$price = $rown['price'] ;
	//get details of the admin
	$st = $_SESSION['st'] ;
	$ctry = $_SESSION['ctry'] ;
	$city = $_SESSION['city'] ;
	if(!$_SESSION['rs'] )
	{
		$rs = 'nill' ;
	}
	else
	{
	$rs =  $_SESSION['rs'] ;
	}
	
	if(isset($_POST['submit']))
	{
		if($getproduct->rowcount() > 0)
		{
		 
		$icode =  $pcode ;
		$bag =  $_POST['bag'];
		$halfbag =  $_POST['halfbag'];
		$penta =  $_POST['penta'];
		$halfpenta =  $_POST['halfpenta'];
		$liter =  $_POST['liter'];
		$cup = $_POST['cup'];
		$mb = 'Bag' ;
		$mhb = 'Half Bag' ;
		$mp = 'Penta Bucket' ;
		$mhp = 'Half Penta' ;
		$mc = 'Cup' ;
		$ml = 'Liter' ;
		$stmt = $DB_con->prepare("update grain set amount = :c where (productcode =:a and measure =:b)") ;
		$stmt->bindparam(":a", $icode) ;
		$stmt->bindparam(":b", $mb) ;
		$stmt->bindparam(":c", $bag) ;
		$stmt->execute() ;
		
		$stmt1 = $DB_con->prepare("update grain set amount = :c where (productcode =:a and measure =:b)") ;
		$stmt1->bindparam(":a", $icode) ;
		$stmt1->bindparam(":b", $mhb) ;
		$stmt1->bindparam(":c", $halfbag) ;
		$stmt1->execute() ;
		
		$stmt2 = $DB_con->prepare("update grain set amount = :c where (productcode =:a and measure =:b)") ;
		$stmt2->bindparam(":a", $icode) ;
		$stmt2->bindparam(":b", $mp) ;
		$stmt2->bindparam(":c", $penta) ;
		$stmt2->execute();
		
		$stmt3 = $DB_con->prepare("update grain set amount = :c where (productcode =:a and measure =:b)") ;
		$stmt3->bindparam(":a", $icode) ;
		$stmt3->bindparam(":b", $mhp) ;
		$stmt3->bindparam(":c", $halfpenta) ;
		$stmt3->execute();
		
		$stmt4 = $DB_con->prepare("update grain set amount = :c where (productcode =:a and measure =:b)") ;
		$stmt4->bindparam(":a", $icode) ;
		$stmt4->bindparam(":b", $mc) ;
		$stmt4->bindparam(":c", $cup) ;
		$stmt4->execute();
		
		$stmt5 = $DB_con->prepare("update grain set amount = :c where (productcode =:a and measure =:b)") ;
		$stmt5->bindparam(":a", $icode) ;
		$stmt5->bindparam(":b", $ml) ;
		$stmt5->bindparam(":c", $liter) ;
		$stmt5->execute();
		
		header("location: home.php") ;
		}
		else
		{
			 
		$icode =  $pcode ;
		$bagm =  $_POST['bag'];
		$bag = 'Bag' ;
		$halfbagm =  $_POST['halfbag'];
		$halfbag = "Half Bag" ;
		$pentam =  $_POST['penta'];
		$penta = 'Penta Bucket' ;
		$halfpentam =  $_POST['halfpenta'];
		$halfpenta = "Half Penta" ;
		$literm =  $_POST['liter'];
		$liter = 'Litre' ;
		$cupm = $_POST['cup'];
		$cup = "Cup" ;
				
 		$stmt = $DB_con->prepare("insert into grain (measure,productcode,amount) values(:a,:b,:c)" ) ;
		$stmt->bindparam(":a", $bag) ;
		$stmt->bindparam(":b", $icode) ;
		$stmt->bindparam(":c", $bagm) ;
		$stmt->execute() ;
		
		$stmt2 = $DB_con->prepare("insert into grain (measure,productcode,amount) values(:a,:b,:c)" ) ;
		$stmt2->bindparam(":a", $halfbag) ;
		$stmt2->bindparam(":b", $icode) ;
		$stmt2->bindparam(":c", $halfbagm) ;
		$stmt2->execute() ;
		
		
		$stmt3 = $DB_con->prepare("insert into grain (measure,productcode,amount) values(:a,:b,:c)" ) ;
		$stmt3->bindparam(":a", $penta) ;
		$stmt3->bindparam(":b", $icode) ;
		$stmt3->bindparam(":c", $pentam) ;
		$stmt3->execute() ;
		
		$stmt4 = $DB_con->prepare("insert into grain (measure,productcode,amount) values(:a,:b,:c)" ) ;
		$stmt4->bindparam(":a", $halfpenta) ;
		$stmt4->bindparam(":b", $icode) ;
		$stmt4->bindparam(":c", $halfpentam) ;
		$stmt4->execute() ;
		
		$stmt5 = $DB_con->prepare("insert into grain (measure,productcode,amount) values(:a,:b,:c)" ) ;
		$stmt5->bindparam(":a", $liter) ;
		$stmt5->bindparam(":b", $icode) ;
		$stmt5->bindparam(":c", $literm) ;
		$stmt5->execute() ;
		
		$stmt6 = $DB_con->prepare("insert into grain (measure,productcode,amount) values(:a,:b,:c)" ) ;
		$stmt6->bindparam(":a", $cup) ;
		$stmt6->bindparam(":b", $icode) ;
		$stmt6->bindparam(":c", $cupm) ;
		$stmt6->execute() ;
		
		header("location: home.php") ;
	}	
		
	
	
	}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Update</title>

<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">

<!-- Optional theme -->
<link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">

</head>
<body>

<?php include('head.php') ; ?>

<div class="container">


	<div class="page-header">
    	<h1 class="h2">Adding New Item<a class="btn btn-default" href="home.php"> <span class="glyphicon glyphicon-eye-open"></span> &nbsp; view all </a></h1>
    </div>
    

	<?php
	if(isset($errMSG)){
			?>
            <div class="alert alert-danger">
            	<span class="glyphicon glyphicon-info-sign"></span> <strong><?php echo $errMSG; ?></strong>
            </div>

            <?php
	}
	else if(isset($successMSG)){
		?>
        <div class="alert alert-success">
              <strong><span class="glyphicon glyphicon-info-sign"></span> <?php echo $successMSG; ?></strong>
        </div>
        <?php
	}
	?>   

<form method="post" enctype="multipart/form-data" class="form-horizontal" style="width:70%; margin-left:auto; margin-right:auto;">
<center><h3><?php echo $product ; ?>..Price Per Bag : <?php echo $price ; ?> </h3></center>
<br/>
	<div class="alert alert-success">    
	<center>
    
    <label>PRICE PER BAG</label>
    <input type="text" name="bag" value="<?php echo $perbagx ; ?> " placeholder="Enter price per bag" class="form-control" />
     <label>1/2 BAG</label>
    <input type="text" name="halfbag" value="<?php echo $halfbagx ; ?>" placeholder="Enter price per 1/2 bag" class="form-control" />
     <label>PENTA BUCKET</label>
    <input type="text" name="penta" value="<?php echo $perpentax ; ?>" placeholder="Enter price per PENTA" class="form-control" />
     <label>1/2 PENTA BUCKET</label>
    <input type="text" name="halfpenta" value="<?php echo $halfpentax ; ?>" placeholder="Enter price per 1/2 PENTA" class="form-control" />
     <label>PER LITRE</label>
    <input type="text" name="liter" value="<?php echo $perliterx ; ?>" placeholder="Enter price per Liter" class="form-control" />
     <label>PER CUP</label>
    <input type="text" name="cup" value="<?php echo $percupx ; ?>" placeholder="Enter price per cup" class="form-control" />
    
    <br/>
    <input type="submit" name="submit" value="Update Records" class="btn btn-danger" />
    
    
    </center>
 </div>   
</form>



<div class="alert alert-info">
      <?php include('footer.php') ; ?>
</div>

    

</div>



	


<!-- Latest compiled and minified JavaScript -->
<script src="bootstrap/js/bootstrap.min.js"></script>


</body>
</html>
<script></script>